Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N9272PH&R Aircraft LLC · Kansas City, MOBuilt 1968 · S/N 24-4772 N9272YIal Corp · Lewes, DEBuilt 1984 · S/N 31P-8414039 N9274PMurray John F · Crystal Lake, ILBuilt 1968 · S/N 24-4774 N92765N92765 Inc Trustee · Wilmington, DEBuilt 1996 · S/N 4636070 N9276PHansen Stephen J · Redmond, WAS/N 24-4776 N9279PArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1968 · S/N 24-4780 N927DMGoat Rancho LLC · Euless, TXS/N 32-40225 N927PTReds Asset Managers LLC · Pottsville, PABuilt 1976 · S/N 27-7754008 N9280KN9280k LLC · Miami, FLBuilt 1997 · S/N 4636109 N92811Stephen Beazley Builders Inc · Evans, GABuilt 1996 · S/N 4636076 N9281BClear View Inc · Fort Smith, ARBuilt 1996 · S/N 4636074 N92821Aerinova Inc · Mattoon, ILBuilt 1997 · S/N 4636081 N92835Ruff Aviation LLC · Asheville, NCBuilt 1997 · S/N 4636097 N9284X84x Leasing LLC · Idaho Falls, IDBuilt 1997 · S/N 4636087 N9285QJrb Aviation Ltd · Jasper, GABuilt 1997 · S/N 3257023 N92884Bas Part Sales LLC · Greeley, COBuilt 1997 · S/N 4636107 N9288PLivingston Jerry D · Wichita, KSBuilt 1968 · S/N 24-4788 N9289PSvetlik Ludvik Julius · Victoria, TXS/N 24-4789 N928HLJ & M Sales & Leasing LLC · Abingdon, ILS/N T20608066 N9292NN9292n LLC · Valdosta, GABuilt 1997 · S/N 3257008 N9292PRegistered aircraftBuilt 1968 · S/N 24-4791 N9292YWeisend Chad M · Logansport, INBuilt 1969 · S/N 31-387 N9293PCenterline Holdings Inc · Camden, DEBuilt 1968 · S/N 24-4792 N9293YBecker Ryan · Sheldon, IABuilt 1985 · S/N 32R-8629004 N9294PJensen Thomas · Durango, COBuilt 1968 · S/N 24-4793 N9295GMcavian LLC · Westworth Village, TXBuilt 1997 · S/N 3257017 N9296NSunrider Aviation Inc · Irvine, CABuilt 1997 · S/N 3257013 N9296PStevens John W · Westlake Village, CABuilt 1968 · S/N 24-4795 N9297P9797p LLC · San Angelo, TXBuilt 1968 · S/N 24-4796 N9298DAims Air LLC · Kingsport, TNBuilt 1997 · S/N 3257002 N9299PFusion Flight Management LLC · Lake Havasu City, AZBuilt 1997 · S/N 4636123 N9299XSchoepel Alexandra E Trustee · Templeton, CABuilt 1997 · S/N 3257021 N929DJA And S Flying Services Inc · Bristol, VABuilt 2004 · S/N 3257344 N929JMCalhoun Paul M · Larue, TXS/N 3319 N929RRPanafax LLC · Wilmington, DEBuilt 1997 · S/N 4636115 N92BLIsland Birds Inc · St Thomas, VIS/N 31-7852095 N92DMD & M Flyers LLC · Petoskey, MIBuilt 1978 · S/N 27-7854107 N92ECStevens Faustin R · Kennewick, WABuilt 1977 · S/N 32R-7880007 N92EJSecond Life Properties LLC · Salisbury, MDBuilt 1978 · S/N 32R-7885242 N92GTBlue Skies Aviation LLC · Riverdale, MDBuilt 2002 · S/N 2100 N92HDN242ak LLC · Ocala, FLBuilt 2003 · S/N 3257326 N92HRSweetsholdings LLC · Lewisville, TXBuilt 1970 · S/N 31-649 N92JWKennedy Donald R Jr · New Philadelphia, OHBuilt 1974 · S/N E600 N92LLTanner Dave · Auburn, CABuilt 2000 · S/N 3257191 N9303PDyster Justin C · Coeur D Alene, IDBuilt 1968 · S/N 24-4799 N930KGGriggs Roger · Columbia, SCS/N 32R-8029027 N930MDTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1967 · S/N 27-3787 N930ZMirage 930 Corp Trustee · Wilmington, DEBuilt 1995 · S/N 4622188 N9312PGregory John P · Riverside, CABuilt 1969 · S/N 24-4808 N9313PPencosky Edward A Jr · Manorville, NYBuilt 1969 · S/N 24-4809

Back to AD 81-12-06 R1