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.
N819DJMaljaars Jack A · Prosser, WAN819DWMarchio Anthony J · Flower Mound, TXN819EJLietzan Ernest W · Appleton, WIN819GHFincher James B · Roanoke, ALN819JBChance Billy M · Normangee, TXN819JKHaviland John G · Fenton, MIN819JSZnamenacek Kevin L · Western, NEN819KKochman Robert W · Kirkland, WAN819KSN819ks LLC · Palm City, FLN819MWPussy Galore Aviation LLC · Kalispell, MTN819PASkywest Leasing Inc · St George, UTN819PRHernandez Galin · Saint Augustine, FLN819PSWoodard William R · University Place, WAN819RTLeatherwood Michael W · Granbury, TXN819SBCarroll Justin · Harrisburg, NCN819SMAnderson George M · Hattiesburg, MSN819TAStout Brent B Trustee · Hickman, CAN819TTHillsboro Aero Academy LLC · Hillsboro, ORN819VKRosiere Jason Daniel · Haslet, TXN819WWMaier Ryan D · Bemidji, MNN81AVShyan Inc · Thomasville, NCN81BAAscent Aviation Inc · Van Nuys, CAN81BHPalmer Robert E · Cedar Key, FLN81BJBudahn Christopher W · Kenyon, MNN81BSFairchild Donald R · Ringgold, GAN81CAColeman Aeroclub · Apo, AEN81CYKrueger Nicholas P · Somerset, WIN81DGRae Seth R · Spotsylvania, VAN81DHMusser Scott S · Pasco, WAN81DMArcanum LLC · Lake Orion, MIN81DSMarathon Leasing Inc · Elyria, OHN81ECWalker Robert · Chula Vista, CAN81EDNav-Pete LLC · Memphis, TNN81EMMalone Mark R · League City, TXN81FBStack John A · Trenton, SCN81GTCamgo LLC · Kenosha, WIN81GWWolfe Ian Sean · Spring Branch, TXN81JACsukay Orkideh · Reseda, CAN81JDBarbour Grays Inc DBA · Buckhannon, WVFirst renewal noticeN81JFMains Donald L · Hiram, MEN81JRPlane Fun Inc Tr Trustee · Snellville, GAN81LBGaravaglia Gary E · Statesville, NCN81LCBynum Leo M · Albuquerque, NMN81LKKinder Larry R · Fort Myers, FLN81LLJma Aviation LLC · Lakin, KSN81LMMission Flight Academy · Yucaipa, CAN81LSPedulla Rich · Wyalusing, PAN81MBBradford Michael H · Zephyr Cove, NVN81MDTt Twins LLC · Fayetteville, GAN81MFSchneider Paul Scott · Manahawkin, NJ
Back to AD 87-10-06 R1