Skip to content

Registered aircraft · 54,017

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.

N4842DTablerock Cattle Co LLC · Lacrosse, WABuilt 1958 · S/N 34942 N4842KKinetic Group LLC · Eagle, IDBuilt 1979 · S/N P21000343 N4842QBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802578T N4842UMadsen Gerald H · Seattle, WAFirst renewal noticeBuilt 1964 · S/N 2050542 N4842XKlemann Rose Marie · West Glacier, MTBuilt 1966 · S/N 15064892 N4843BMaddox Emily Brown · Rosharon, TXBuilt 1979 · S/N 15283668 N4843CPayne Thomas E · Old Forge, NYBuilt 1975 · S/N 18502611 N4843RFriesenborg & Larson Custom Spraying Lc · Buffalo Center, IABuilt 1975 · S/N 18802362T N48440Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280910 N4844DLewis Joseph W · Decatur, TXS/N 34944 N4844FKnightair Enterprises LLC · Caro, MIFirst renewal noticeBuilt 1979 · S/N 17273088 N4844JSkoglun Eric W · Cashmere, WABuilt 1979 · S/N 17273684 N4844KMccoy Robert G Jr · Marshville, NCBuilt 1979 · S/N P21000344 N4844NTurbyfill Tony L · Vina, ALBuilt 1979 · S/N 18267414 N4845CBloss Albert P · Seattle, WABuilt 1979 · S/N 21063642 N4845EEllis Jeffrey · Davis, ILBuilt 1979 · S/N 18503887 N4845GNation Linda S · Sanford, FLBuilt 1979 · S/N 17273392 N4845JL&J Aviation Inc · Atwater, CABuilt 1979 · S/N 17273685 N4845UKris Noone Air LLC · Wilmington, DES/N 205-0545 N4846DYoung Jason · Anchorage, AKBuilt 1958 · S/N 34946 N4846GNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 1979 · S/N 17273393 N4847BCrossbrook LLC · Willoughby, OHBuilt 1979 · S/N 15283670 N4847GFlying Daze · Batavia, OHBuilt 1979 · S/N 17273394 N4847UTaylor Livingston · Watertown, MABuilt 1964 · S/N 205-0547 N48481Oklahoma State University · Stillwater, OKBuilt 1979 · S/N 15283342 N4848DThompson Kelly W · Portland, ORBuilt 1959 · S/N 52082 N4849DN4849d LLC · North Logan, UTBuilt 1979 · S/N 17272372 N4849JEast Side Mosquito Abatement District · Modesto, CABuilt 1981 · S/N 18803773T N4849QSouther Field Aviation Inc · Americus, GABuilt 1976 · S/N 18802585T N4849XSeyfer Bradley W · Renton, WABuilt 1966 · S/N 15064899 N484KWNunez-Fontes Fernando · Rio Rico, AZBuilt 1980 · S/N 21064066 N485Obenchain David W · Simi Valley, CABuilt 1959 · S/N 50595 N48500R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280914 N4850GPeters Walter C · Rockford, ILBuilt 1979 · S/N 17273397 N4850HGreen Airport Development Corp · Kemah, TXBuilt 1979 · S/N 15283985 N4850SWood Josh A · Chino Hills, CAS/N R182201438 N4850URegistration Pending · Elsie, MIRegistration pendingS/N 205-0550 N4851BCode Supplies Inc · Lakeland, TNBuilt 1979 · S/N 15283673 N4851GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273398 N4851JAbernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 18803774T N48521Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283346 N4852ESproul David Douglas Jr · Heath, TXBuilt 1979 · S/N 18503888 N4852GR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273399 N4852PGreenwood Auto LLC · Itta Bena, MSBuilt 1980 · S/N 15284831 N4852VR & R Aviation Services LLC · Darien, ILS/N 172RG0400 N4853CIdaho Flying Service LLC · Kamiah, IDS/N U20603851 N4853DCrosgrove Shawn R · Riverton, UTBuilt 1958 · S/N 34953 N48549Davies Richard E · Sequim, WABuilt 1979 · S/N 15283349 N4854GMilwaukee Aero LLC · Milwaukee, WIBuilt 1979 · S/N 17273401 N4854RFisher Ag Service LLC · Cardington, OHBuilt 1975 · S/N 18802373T

Back to AD 87-20-03 R2