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.
N8255JBerkshire Aviation Enterprises LLC · Great Barrington, MAN8255MPhoenix Wings LLC · Oakland, FLN8255PKanooth Michael L · Washougal, WAN8255RTwo River Airspray LLC · Cavalier, NDN8255WReed Emerson E · Winter Haven, FLN82563Registered aircraftN82566Low James E · Fairbanks, AKN8256EWilliams Evan H · Sebastopol, CAN8256LNordbye Newell H · Eden Prairie, MNN8256PHouse Terry J · Mountain View, ARN8256VZ-Tech Research LLC · Greenville, TXN8256WInland Northwest Flyers LLC · Spokane Vly, WAN8256XSkyriders Inc · Pocatello, IDN8256YPhill-Air Inc · Dover, DEN82575Rocky Gary B · Campbell, TXN82577Sale Reported · Wasilla, AKSale reportedN8257ETv Air LLC · Raleigh, NCN8257GDraco Flight School Inc · Chino, CAN8257JGruber Larry E · Delphi, INN8257PWipf Ryan C · Mound, MNN8257WHou Barry · San Marino, CAN8258JKenyon Travis · Phoenix, AZN8258LWiesner Loren A Jr · Cameron, WIN8258NK&G Transit LLC · Fort Mc Coy, FLN8258PThings That Fly LLC · Phoenix, AZN8258RNewo Aviation LLC · Garden City, KSN8258WWirkus Branden D · Apo, AEN8258YJohnson David C · Chisago City, MNN82591Cornia Mike D · Wasilla, AKN82598Foothill Aviation LLC · Iliamna, AKN8259BDunn Patrick E · Marthasville, MON8259GCappello Dave Allen · Cottonwood, CAN8259NAughenbaugh Timothy A · Iriquois, SDN8259TNsa Ops LLC · Kahului, HIN8259WMorrison Daniel S · Hershey, PAN8259YRyan Ferguson LLC · Sanford, FLN825ABAchord James D · Decatur, ALN825ALN825al LLC · Freeport, NYN825CRWolken Ralph E · Shady Shores, TXN825DEYouderian Kenneth E · Coupeville, WAN825ERFlying Aces Aero-Fleet Inc · Guyton, GAN825HBGallegos Joel · Yellville, ARN825KBBrech Robert M · Greenbrier, ARN825KSPlanelease LLC · Venice, CAN825PBPalm Beach Aircraft Services Inc · Lantana, FLN825PMKidd Paul C · Vestavia Hills, ALN825PTIcarus Flyers LLC · Richmond Hill, GAN825RDFrank Richard · West Dundee, ILN825SHJ L Loewen Md Sc · Niagara, WIN825TJTakeflight LLC · American Fort, UT
Back to AD 87-10-06 R1