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.
N9644JLeckliter Michael A · Murrieta, CAN9644KLuck Aviation LLC · Glen Allen, VAN9644MBurley Joseph D · Fayetteville, GAN9644QSkyhawks Inc · Chippewa Falls, WIN9645DDarryn Allyson R · Las Cruces, NMN9645HSantiago Diana L · Juana Diaz, PRN9645JLuxury Vacations Inc · Scottsdale, AZN9645VOak Ridge Flyers Inc · Oak Ridge, TNN9646BN9646b LLC · Wilmington, DEN9646DFerrell Alan B · Arlington, OHN9646KHumphreys Garfield · Port Saint Lucie, FLN9646RB-Dog Aviation LLC · Grand Junction, CON9646WOgier Gerard Paul · Hampton, NHN9647BLakewood Investments LLC · Victorville, CAN9647DSutton Neal · Ashby, NEN9647MSoaring Eagle Flying Club · Midland, MIN9647QKaeni Law Group Inc · Santa Ana, CAN9647UWilhite Randall D · Plainville, MAN9647WAirplanes Plus Inc · Marathon, FLN9648BBarker David C · Lumberton, NCN9648HSaunders Larry F · Sulphur Springs, ARN9648MN9648m LLC · Louisville, KYN9648QGreen Bay Flying Club Inc · Krakow, WIN9648VGrove Kaylene · San Diego, CAN9648WMccullough Dwayne D · Onancock, VAN96493Smtm Holdings Inc · Wilmington, DEN9649BGoebel Christian E · Luray, VAN9649DUlrich Kenneth B Jr · Kingwood, TXN9649JRegistration Pending · Springboro, OHRegistration pendingN9649PHarris Hill Soaring Corp · Horseheads, NYN9649VLagorce Victor X · Owasso, OKN9649WWard Travis E · Tucson, AZN964AAFlorida Flight Training Center Inc · Venice, FLN964ABSmith Craig W · Horton, MIN964AC63 Victor LLC · Fremont, OHN964ALMay Robert E · Payson, AZN964DJMcculloch Randall L · Romulus, NYN964GRRene Gary W · Alamo, TXN964HLGraham Huber L · Gulf Breeze, FLN964JCIceman Air LLC · Stafford, VAN964LAHarriman Robert M Sr · Grand Isle, VTN964LJAir Mercury LLC · New Rochelle, NYN964MMModular Aviation LLC · Saratoga Springs, UTN964PLBlue Sky Industries LLC · Wilmington, DEN964RNNoyes Randall L · Henderson, NVN964SEGray Luke Francis · San Bruno, CAN964SHI1 Aviation LLC · Wilmington, DEN964SMMatta Sam · Houston, TXN964SPDirty Side Down Aviation LLC · Georgetown, TXN964TEBedard Robert L · Bolivar, OH
Back to AD 87-10-06 R1