AD 81-18-04 R2
Registered aircraft · 81,733
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
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-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.
N9281KBartels Aviation LLC · Merritt Island, FLN9281MJakobsen Anders M · Norcross, GAFirst renewal noticeN9281RBmg Aviation Leasing LLC · Bloomington, INN9281SBmc2 LLC · Phoenix, AZN9281VJohnson Jerry W · Westlake, TXN9282CRegistration Pending · Augusta, KSRegistration pendingN9282FBox Helicopters Inc · Cotulla, TXN9282MRainey Michael N · Cleveland, TNN9282PCampbell Paul · Glade Spring, VAN9282SMorgan John S · Athens, ALN92837Staszak Sandra · Martinsville, ILN9283AFf22 LLC · Scottsdale, AZN9283JN9283j LLC · Boise, IDN9283MHazelswart India A · Chase City, VAN9283SRegistration Pending · Johnson City, TNRegistration pendingN9283WJohnson Mark A · Norfolk, NEN92845Hainet Aero LLC · Wilmington, DEN9284AGriffith Nathan · Boston, MAN9284KMtm Aviation LLC · Lake Havasu City, AZN9284LWilkins Perry · Chesapeake, VAN9284MNationwide Aviation LLC · Hudson Oaks, TXN9284PDickinson Malcolm · Stamford, CTN9284STamad Aviation LLC · Tracy, CAN9284TGarrett Randall F · Fort Walton Beach, FLN9284VBloomer Garett · Ballston Lake, NYN9284WGutierrez Daniel M · Kennett Square, PAN9284ZFlex Aircraft Leasing Co LLC · Detroit, MIN9285November 9285 LLC · Higden, ARN92855Falcon Flying Club · Mesa, AZN9285CSunset Flights LLC · Azusa, CAN9285HOrion Aviation Aircraft LLC · Carlsbad, CAN9285JCope Jarret C · Lexington, NCN9285M5 M Leasing LLC · Englewood, CON9285PStumpf Bernard L · Westerly, RIN9285VEllsworth Bryan E · Garden City, UTN9285YUeeck Brett A · Anchorage, AKN9286Drent Ethan M · Greenwood, INN9286DCaldwell Bob · Columbus, MSN9286FFlying High Like A Bird In The Sky · Longwood, FLN9286MWiley Aviation LLC · Murfreesboro, ARN9286TMccabe Robert C Jr Trustee · Santa Rosa Beach, FLN9286VRupinski Casimir Michael III · Cape May, NJN9286WAmigos Flight Club LLC · Schertz, TXN92873Sonday Terrance P · Spring, TXN92878Jackson Richard L · Indianapolis, INN9287ESkyborne Airline Academy Inc · Vero Beach, FLN9287MRkm Leasing LLC · Greenwich, CTN9287SDale Michael W · Clayton, NCN9287VRuschman Vaughn M · Boise, IDN92886Lewis John E · Clayton, NJ
Back to AD 81-18-04 R2