Registered aircraft · 17,028

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N8513JHurd Billy R · North Pole, AKBuilt 1967 · S/N 15066413 N8513SBeach Thomas C III · Salado, TXBuilt 1965 · S/N 18256613 N8514UDyck Johan · Key Largo, FLBuilt 1964 · S/N 17252414 N8515SHawkins Kenneth Roger · Globe, AZBuilt 1965 · S/N 18256615 N8516MSealane LLC · Burlingame, CABuilt 1970 · S/N 18260446 N8516SReik Thomas Donaldson Jr · New Port Richey, FLBuilt 1965 · S/N 18256616 N8517STardif Jean Y · Moorpark, CABuilt 1965 · S/N 18256617 N8517UNortheast Cubs LLC · Wilmington, DEBuilt 1964 · S/N 17252417 N8518GDouble Rr Holdings LLC · Dallas, TXBuilt 1965 · S/N 15062618 N8519GSullivan Aviation Maintenance LLC · Fayetteville, NCS/N 15062619 N8519SCinden LLC · Nashua, NHBuilt 1965 · S/N 18256619 N851LW578 Airplane Leasing Inc · Kissimmee, FLBuilt 1968 · S/N 17257189 N8520SClark Joseph D · Kilgore, TXBuilt 1965 · S/N 18256620 N8522JValley Jacob A · Brewer, MEBuilt 1967 · S/N 15066422 N8522UHebbronville Machine Shop Llp · Hebbronville, TXBuilt 1964 · S/N 17252422 N8523GStephany Peter T · Umatilla, FLS/N 15062623 N8523UEllis Clifford E · Emmitsburg, MDFirst renewal noticeS/N 17252423 N8524SLoyer Victor D · Palmer, AKBuilt 1965 · S/N 18256624 N8524ULewis Steven · Anchorage, AKBuilt 1964 · S/N 17252424 N8525JBicknell Hilary E · Warwick, RIS/N 15066425 N8526GLong Sean · Germantown, TNBuilt 1966 · S/N 15062626 N8527GAcosta Alfredo · Yuma, AZBuilt 1965 · S/N 15062627 N8528GTulsa Technology Center School Dist No 18 · Tulsa, OKBuilt 1965 · S/N 15062628 N8528SLucas Robert I · Jackson, WYS/N 18256628 N8529JBrucks Mark D · Peachtree City, GABuilt 1967 · S/N 15066429 N8529SWollan David · Shelby, MTBuilt 1965 · S/N 18256629 N8531JCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 15066431 N8532JWerner Felix A · Picayune, MSBuilt 1967 · S/N 15066432 N8532UMethe James L · Omaha, NEBuilt 1964 · S/N 17252432 N8533USustarich Stephen M · Ketchikan, AKBuilt 1964 · S/N 17252433 N8534GBennett Julie L · Titusville, FLBuilt 1965 · S/N 15062634 N8534SBorreson Anthony · Mariposa, CABuilt 1965 · S/N 18256634 N8534ULusson Adam R · Cameron, WIBuilt 1964 · S/N 17252434 N8535GSpeedbird Aviation One LLC · Glenn Heights, TXBuilt 1965 · S/N 15062635 N8535UGibbons Patrick C · Sunrise Beach, TXBuilt 1964 · S/N 17252435 N8536GMarcu David · Killen, ALS/N 15062636 N8536SClear Skies Aviation LLC · Reserve, MTBuilt 1965 · S/N 18256636 N8537GNugent David R · Jensen Beach, FLBuilt 1965 · S/N 15062637 N8537UHarrington Richard E · Bly, ORS/N 17252437 N8538UMullaly George J · Rockville Centre, NYBuilt 1964 · S/N 17252438 N8539SFarmair Inc · Hughesville, PABuilt 1965 · S/N 18256639 N8540JSale Reported · Lamar, COSale reportedBuilt 1967 · S/N 15066440 N8541GDeseh Sarah · San Diego, CABuilt 1965 · S/N 15062641 N8541UHegg Kevin S · Ann Arbor, MIBuilt 1965 · S/N 17252441 N8542JMcdowell Donald L · Geneva, OHBuilt 1967 · S/N 15066442 N8544UKeeley Edward D · Konawa, OKBuilt 1965 · S/N 17252444 N8545SRnr Aviation LLC · Malaga, WABuilt 1965 · S/N 18256645 N8546UShouling & Philip Enterprise · Lancaster, CABuilt 1964 · S/N 17252446 N8547JL&R Consulting LLC · Las Vegas, NVBuilt 1967 · S/N 15066447 N8549UFauver Russell · Hartsville, SCS/N 17252449

Back to AD 72-03-03 R3