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.
N6675ZBoomer Aviation Inc · Fort Walton Beach, FLN6676JRozof Chester F · Fort Myers, FLN6676RJackson Michael W · Bedford, TXN6676WWorkman Industries Inc · Durant, IAN6677HPeterson Robert E · Richland, WAN6677WOsgood Darrell F · Watervliet, MIN6678FAircraft Guaranty Corp Trustee · Oklahoma City, OKN6678JWiener Ronald K · Tucson, AZN6678WMadison Andrew J · Inver Grove, MNN6679PJmj Aviation LLC · Kalispell, MTN6679UKimbrough Edward W · Houston, TXN667BAAmendala Brian R · Hillsboro, ORN667CHBorders Darin · Center, TXN667CRKnieling Gene A · Rush Center, KSN667DTGinter Jon A · Marlton, NJN667LBChristiansen Aviation LLC · Wilmington, DEN667LDLeading Edge Aviation LLC · Manchester, MON667QTevik Michael A · Provo, UTN667RHN667rh LLC · Oakdale, NYN667SAHelicopter N667sa LLC · Lisbon, NDN667SCSpartan Education LLC · Tulsa, OKN667SPHindi David · Cupertino, CAN667TCT J Aviation LLC · Kennesaw, GAN6680EPrax Philip · Fairbanks, AKN6680JElliott Bryn · Blue Point, NYN6680PWilliams Aaron J · Addison, TXN6680RWestlake Mark A · Jewett, OHN6681PHouse Charles D · Tunkhannock, PAN6681UGriffin Josh R · Minot, NDN6681XSky Harbor Aviation LLC · Powder Springs, GAN6682LDeyo Kenneth F · Thomaston, CTN6682RCavazos Jose Luis Jr · Houston, TXN6682YMcdermott James R · Somerton, AZN66836Wolgemuth Jim · Anchorage, AKN6683UReisner Kenneth D · Lecompte, LAN66842Gelvin Stanley M · Central, AKN6684PN6684p LLC · Kalispell, MTN6684RRoberts Alec · Boulder, CON6684UFowler Kenneth G · Newport, TNN6684WWaltman Richard Dean · Moses Lake, WAFirst renewal noticeN6685UMccroskey Wesley D · Kingston, TNN6685WZulueta David · Louisville, GAN6686LHartmann Peter F · Paulden, AZN6686RAnderson Benjamin P · Bellevue, NEN6686UNorstegaard Mark A · Sturgis, SDN6687CHurtt Ben J · Mountain Grove, MON6687JRio Creek Aviators Ltd · Casco, WIN6687WHolland William A · Brownwood, TXN6687ZCrop Doctor Aviation Inc · Hill City, KSFirst renewal noticeN66884Sea2ski Flying Club Inc · Anchorage, AK
Back to AD 87-10-06 R1