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.
N825XSktr Ac LLC · Fallbrook, CAN82600Hendrickson Ryan H · Gunnison, UTN8260NSundberg Nicholas William · Stevensville, MTN8260VRed Rifle Aviation LLC · Richmond, TXN8260YNew Peach Aviation LLC · Brooks, GAN82613Wammen Ranch Llp · Reva, SDN82616Fisher D Bradley · Cleveland, TNN82617Cooper Holly B · Friendswood, TXN82618Lechner Burdette J · Kodiak, AKN82619Cherry Hill Aviation Inc · Freetown, INN8261HOxford Flying Club Inc · Oxford, CTN8261PWarzek Mary Ann · Halfmoon, NYN8261SHoffmann David M · Mauston, WIN8261TDoss Brothers Inc · Lawrenceburg, TNN8261YWilliams Brannon R · Fort Worth, TXN82629Dgf & Associates Inc · Irving, TXN8262ASnider Jay T · Grove City, OHN8262ESee Robert W · Catawba, NCN8262HRegistration Pending · Bucyrus, OHRegistration pendingN8262JHarris James D · Lasalle, CON8262KHesston College · Hesston, KSN8262N40 Flight LLC · Fernandina Beach, FLN8262SWisconsin Aviation - Four Lakes Inc · Madison, WIN8262UHorton Air Ventures LLC · Eustis, FLN8262WCalhoun Jerry H · Washington, NCN8262YAchamp LLC · Memphis, TNN82631Payne Chris · Lafayette, TNN82634Aircraft Wings LLC · Gresham, ORN82635Chase 13 LLC · Wilmington, DEN8263EN8263e LLC · Jackson, MIN8263JIsaacs David R · Fort Wayne, INN8263NPiper Partners Mbda LLC · Fairfield, ILN8263WViking Crown LLC · Prescott, AZN8263ZBecker Matthew P · Covington, LAN82644Chandler Elijah J S · Pilot Mountain, NCN82646Downs Ricky R Trustee · Roundup, MTN8264GFornwalt Paul A · Linden, PAN8264HAir Dakota Flite Inc · Hettinger, NDN8264JCouch James L · Cochran, GAN8264NRegistered aircraftRegistration pendingN8264PChavez Raul M · Comanche, TXN8264VRuby Jeffrey Steven · Sharon, SCN8264WEyrich Richard L · Cave Creek, AZN8264YPatterson Casey Paul · Kinston, ALN82654Horomanski Eugene E · Duncansville, PAN82656Souther Field Aviation Inc · Americus, GAFirst renewal noticeN8265CDelgado Francisco Trustee · Carmel, INN8265HSlinger LLC · Laramie, WYN8265JConley Donald · Claude, TXN8265NImmanuel Baptist Church Of Kansas City Kansas · Basehor, KS
Back to AD 87-10-06 R1