Skip to content

Registered aircraft · 54,020

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N13541Lowcountry Flying Club · Moncks Corner, SCBuilt 1976 · S/N 17702434 N13543Skylink II LLC · Florissant, MOBuilt 1973 · S/N 17262836 N13544Registered aircraftBuilt 1973 · S/N 17262837 N13548Havana Flyers Assoc · Petersburg, ILBuilt 1973 · S/N 17262840 N13549Big Sky Communication & Cable Inc · Billings, MTBuilt 1973 · S/N 17262841 N1354DKepler Rodney S · Fargo, NDBuilt 1951 · S/N 19930 N1354ESandra And Mose Rucker III LLC · Perrineville, NJBuilt 1982 · S/N 18268175 N1354QBaker Wayne E · Crossville, TNBuilt 1971 · S/N 15072654 N1354UVosskuhler Darlene Duke · Sun City West, AZBuilt 1976 · S/N 17267025 N13551Eagle Sky Patrol Inc · Deadwood, SDBuilt 1973 · S/N 17262843 N13552Newton Property Leasing LLC · Greene, IABuilt 1973 · S/N 17262844 N13555Krueger Steven T · Leander, TXBuilt 1973 · S/N 17262846 N13558Seitz Dennis · Wausau, WIBuilt 1973 · S/N 17262847 N13559Bauta Carlos L · Bristol, INBuilt 1973 · S/N 17262848 N1355DDaly Trucking LLC · Paxton, NES/N 19931 N1355FChi Aerospace Inc · Portsmouth, NHBuilt 1979 · S/N 17272998 N1355SFlight Services Limited LLC · Bennett, COBuilt 1976 · S/N 18264918 N13564Cain James W · Big Rapids, MIBuilt 1976 · S/N 17702437 N13565Williams Jim J · Jackson, NJBuilt 1976 · S/N 17702438 N1356DApte John W · Biddeford, MEBuilt 1951 · S/N 19932 N1356FJprg Aviation Inc · Orlando, FLS/N 17272999 N1356MYbarra Xavier · Uvalde, TXS/N 18264294 N1356STc Aviation LLC · Atlanta, GABuilt 1976 · S/N 18264919 N1356UN1356u LLC · Wilmington, DEBuilt 1976 · S/N 17267027 N13573Davis Flying Services LLC · Gaithersburg, MDBuilt 1973 · S/N 17262856 N13574Warner Aric D · Rosamond, CAS/N 7108 N1357CSummit Concepts Inc · Wilmington, DES/N 17702710 N1357QMckenzie Paul · Stockton, CABuilt 1971 · S/N 15072657 N1357SSmith & Smith Inc · Hurricane, WVBuilt 1976 · S/N 18264920 N1357UHarte Ryan D · Lone Star, TXBuilt 1976 · S/N 17267028 N1357YHouse Robert L · Cleveland, GAFirst renewal noticeBuilt 1962 · S/N 17249057 N13586Oreilly Thomas P · Oscoda, MIBuilt 1973 · S/N 17262860 N13587Nasairs Flying Club · Strongsville, OHBuilt 1973 · S/N 17262861 N1358QWilliams Matthew L · Longview, TXBuilt 1971 · S/N 15072658 N1358UWaddill Paula J · Puryear, TNBuilt 1976 · S/N 17267029 N13590Habibelahian Hamid Reza · Jefferson, TXS/N 17262863 N13593Absolute Altitude LLC · Murrieta, CABuilt 1973 · S/N 17262866 N13594Chambers Quentin S · Bellingham, WABuilt 1973 · S/N 17262867 N13596Gary Rollin F · Dallas, TXS/N 17702440 N13597Heeter Michael · Bloomington, MNBuilt 1976 · S/N 17702441 N1359CCromer Aubrey E · Anderson, SCBuilt 1977 · S/N 17702711 N1359DPribbenow John L · Anchorage, AKBuilt 1951 · S/N 19935 N1359MJtal Holdings LLC · Wilmington, DEBuilt 1975 · S/N 18264296 N1359UHokie Flying Club Inc · Christiansburg, VABuilt 1976 · S/N 17267030 N135ANegative Ghost Rider LLC · Bangor, MEBuilt 1966 · S/N 185-0986 N135AUCoppice Aviation Assets LLC · Lewes, DEBuilt 1971 · S/N A1500297 N135DMHarris Michael G · Spokane, WABuilt 1976 · S/N 18052635 N135ESport Flying USA Inc · Ronkonkoma, NYBuilt 1975 · S/N 17266591 N135FPointon Aviation LLC · Baraboo, WIBuilt 1965 · S/N 18256502 N135HMid Continent Aircraft Corp · Hayti, MOBuilt 1952 · S/N 20829

Back to AD 87-20-03 R2