AD 87-10-06 R1
Registered aircraft · 72,010
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-10-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:87-10-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:87-10-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:87-10-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.
N75USJbh Air LLC · Kent, WAN75VEFord Randy L · Tucson, AZFirst renewal noticeN75VXSandberg Tobias · Anchorage, AKN75VYRevell Ricki A Trustee · Monument, CON75XCPenridge Aviation LLC · Portland, ORN7600DMangos Charles A · Rochester, NYN7600FGiles Forrest D · Springtown, TXN7600WWeigley Kasey Jo · Graham, WAN7600YSchell Joseph H · Granbury, TXN76015Aldea Aviation Partners LLC · Encino, CAN76016Cape Fear Aviation Maintenance LLC · Fayetteville, NCFirst renewal noticeN76019Grimley Robert J · Palermo, NJN7601GWright Carl E · Conesville, OHN7601PVictory Holdings LLC · Anacortes, WAN7601URoads End Aero LLC · Erwinna, PAN7601WMartinez Frank M · Folsom, CAN7601YMines Keith A · White Cloud, MIN7602GAirborne LLC · Wilmington, DEN7602JGarrison Rodney Lynn · Atlanta, TXN7602PBischoff Brent J · Bandon, ORN76032Brown Jeffrey A · Wellington, ALN7603CSorbi Aviation Inc · El Cajon, CAN7603GFelstead R Keith Trustee · Medina, NYN7603JMcclain Thomas J · Toledo, OHN7603VHauser Linda L · Ulysses, KSN7603WBe Properties II LLC · North Platte, NEN7603XHanson Scott E · Auburn, CAN76044Williams Cecil R · Clarksville, TNN76047Registration Pending · Muskogee, OKRegistration pendingN7604FKcsi Aerial Patrol Inc · Bakersfield, CAN7604LCnc Aviation LLC · Rollinsford, NHN7604YHennum Gretchen I · Eagle, CON76053Ape LLC · Birmingham, ALN76056Bormuth Alan R · Morganton, NCN7605FPromise Road Aviation Inc · Pendleton, INN7605LEagle Racer LLC · Boca Raton, FLN7605WBrownlow Gail L · Mountain City, TXN7605YPlane Care LLC · Tucson, AZN7606CKuuluka LLC · Lewes, DEN7606JLiburd Edison V · Austell, GAN7606WOlsen Michael D · Woodinville, WAN7607EPowerbelt LLC · Glendale, CAN7607FRolinski Alexander S · Deland, FLN7607GOwens Wilbur · Rch Palos Vrd, CAN7607JMoser Robert W · Flower Mound, TXN7607RScott Mark G Jr · Manvel, TXN7607WZero Seven Whiskey LLC · Dewey, OKN7608FAj Mush LLC · Dearborn, MIN7608JGevry Ronald Joseph Jr · Alpharetta, GAN7608YJohnson Craig · Moreland, GA
Back to AD 87-10-06 R1