AD 87-20-03 R2
Registered aircraft · 54,015
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: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.
N93TPBagley Corydon S · Holladay, UTN94000Champion Aircraft LLC · Valdosta, GAN94006Leading Edge Aviation Inc · Doylestown, PAFirst renewal noticeN9400EVan Anda Aviation LLC · Apopka, FLN9400GMurphy James T · Nashville, TNN9400HRoach John C · Lawrenceburg, KYN9400LMerino Cesar · Washington, DCN9400XWilliams Dutch R · Mohave Valley, AZN94018Northern Air Transport Inc · Mora, MNN9401GNoble Cody Trustee · Ardmore, OKN9401HConstantine Costas T · Newington, CTN9402CMontgomery Robert L · Port Angeles, WAN9402UMayrant Dawson Z · College Station, TXN9402XSewell John · Sugar Grove, ILN94035Husbands David · Bosque, NMN9403CDobson Michael W · Konawa, OKN9403UPaschal Engineering Inc · Houston, TXFirst renewal noticeN9403YFlorida Emergency Management Associations Inc · West Palm Beach, FLN9404BRutledge Dianna G · Winder, GAN9404CBergh Gene H · Roberts, WIFirst renewal noticeN9404HSowell Richard G · San Jose, CAN9404UWhitcomb James F · West Ossipee, NHN94059Moriarty Gerald J · Anchorage, AKN9405CRamsower Charles M · Parma, IDN9405RJones Lance E · Duncan, OKN9405UBishop Michael E · Clarkston, WAN94061Guinn LLC · Bothell, WAN9406UMontgomery Paul Richard · Fredericksburg, VAN94077Milky Way LLC · Fresno, CAN9407CTyrrell Richard E · Central, AKN9407HB2w Corporation · Winona, MNN9407TBodin Logan T · Lake Charles, LAN9407XDriggers Kenneth Jerry · Rialto, CAN9408HWanamaker Jeffrey Cass · Fall City, WAN9408LMccallum David DBA · Napa, CAN9408UTenhoff Lee L · Homer, AKN94097Registration Pending · St Simons Island, GARegistration pendingN9409LLaguna Verde Leasing Inc · Wilmington, DEN9409TBas Part Sales LLC · Greeley, CON9409UFree Wade · Sharon, OKN9409XEnergy Transfer Aviation LLC · Spring, TXN940AMOracle Aviation LLC · Omaha, NEN940FSYogini Modi · Homestead, FLN940RJLaguna Verde Leasing Inc · Wilmington, DEN940WSkyhawks Inc · Westminster, CON9410MWomack David H · Rayville, LAN9410XHendrix Philip R · Corpus Christi, TXN94112Cooper Robert Jb · Wichita, KSN94118Unique Educational Experiences · Long Beach, CAN9411HFeaga Charles C · Abbot, ME
Back to AD 87-20-03 R2