Skip to content

Registered aircraft · 56,578

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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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:79-10-14-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
  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:79-10-14-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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.

N18015Little Bird 150 LLC · Lake Tapps, WABuilt 1972 · S/N 15073732 N1801CRollins Michael Clayton · Pine River, MNS/N 25945 N1801XClark Curtis S · New Carlisle, OHBuilt 1965 · S/N 18255901 N1801ZGould Robert R Jr · Sterling, VABuilt 1962 · S/N 205-0001 N1802Long Randy B · Coleman, TXBuilt 1957 · S/N 34085 N18020N18020 LLC · Chandler, AZBuilt 1972 · S/N 15073736 N18021Tilden Jeffrey D · Columbus, INS/N 15073737 N18023Remain In The Pattern LLC · Meridian, IDBuilt 1972 · S/N 15073739 N18025Evans II Rodney D · Saint Albans, WVBuilt 1972 · S/N 15073741 N18026Registered aircraftBuilt 1976 · S/N 17702525 N1802FSantiago Ferdinand · Calhoun, GABuilt 1965 · S/N 21058702 N1802RMontaska Management Inc · Anchorage, AKBuilt 1974 · S/N 18502518 N1802VWard Robert L Jr · Cleburne, TXBuilt 1974 · S/N 17263756 N1802ZSparks Timothy J · Jackson, MIBuilt 1962 · S/N 205-0002 N18032Old School Aircraft LLC · Jackson, TNBuilt 1972 · S/N 15073747 N18033Barkley John · Austin, TXBuilt 1972 · S/N 15073748 N18038Overton Asset Group LLC · St Marys, IABuilt 1976 · S/N 17702526 N1803CWallner David A · Adell, WIBuilt 1953 · S/N 25947 N1803MWhitfield Edward · Mcpherson, KSBuilt 1975 · S/N 18264454 N1803YOfficial Stripes LLC · New Braunfels, TXBuilt 1962 · S/N 17249403 N18042Carey Daniel F · Rockville Centre, NYS/N 15073754 N18046Beavers David A · Strasburg, COS/N 15073757 N1804FWaage Todd · Greenbush, MNBuilt 1965 · S/N 21058704 N1804VBuskas Blake Rodney · Whitefish, MTS/N R1722214 N1804YSnader Douglas E · West Linn, ORBuilt 1962 · S/N 17249404 N1805Mcgarry Patrick L · Payson, AZBuilt 1972 · S/N 18502038 N18050Jarrell Loyd F · Whitesburg, TNBuilt 1972 · S/N 15073759 N18052Sky Views LLC · Mount Crawford, VABuilt 1972 · S/N 15073760 N18053Kraft Tyrone H · Timber Lake, SDBuilt 1953 · S/N 30548 N18055Plane Fun Inc Tr Trustee · Snellville, GABuilt 1955 · S/N 31463 N18057Palmer Jedidiah J · Lewiston, IDS/N 15073763 N1805CCampbell Stacy D · Buena Vista, COBuilt 1953 · S/N 25949 N18061Foster Rodney D · Quanah, TXBuilt 1972 · S/N 15073765 N18067Get Out Aviation LLC · Palmer, AKS/N 15073769 N18069Olandese Donald J · Newalla, OKBuilt 1972 · S/N 15073771 N1806MCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13177 N1806XBrowning Lonnie O IV · Allendale, SCS/N 18255906 N1806YMadcity Aviation LLC · Madisonville, KYBuilt 1962 · S/N 17249406 N18071Rock River Aviation · Watertown, WIBuilt 1972 · S/N 15073773 N18075Northwestaildraggers LLC · Washougal, WABuilt 1975 · S/N 18052511 N18076Angelos Mark A · Concord, CAS/N 15073776 N1807CMorriss Elvin A · Springdale, ARBuilt 1952 · S/N 25951 N18081Eyes Above LLC · Hampton Falls, NHBuilt 1972 · S/N 15073780 N18088Durin Steven C · Steward, ILS/N 15073784 N1808MPenner Paul R · Bel Air, MDS/N 25952 N1808XM&M Land Company LLC · Marietta, OHBuilt 1964 · S/N 18255908 N1808YHardy Russell L · Rimrock, AZBuilt 1962 · S/N 17249408 N1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedBuilt 1962 · S/N 205-0008 N1809MSkymaster-173 LLC · New Bern, NCBuilt 1971 · S/N 33701409 N1809XMilburn Thomas D Trustee · Lompoc, CABuilt 1964 · S/N 18255909

Back to AD 79-10-14 R1