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.
N6507RJoachim Peter · Grafton, WIN6507UBovey Dominic C · Sandpoint, IDN6508HBkb Inc · Newport, MIN6508KTroy Oakland Pilots Flying Club Inc · Troy, MIN6508RSterling Creek LLC · Brookings, SDN6509HSale Reported · Benton, KSSale reportedN6509JRoot Rickey · Nederland, TXN6509RHolzhauer Aviation Corp · Middletown, DEN650FLHarps Thomas B · Vilonia, ARN650FTFlorida Institute Of Technology · Melbourne, FLN650MATerra Flight Aerial Imaging Inc · Spring, TXN650NDUniversity Of North Dakota · Grand Forks, NDN650PA-Z Leasing LLC · Kenosha, WIN650PKKarmouche Paul · Penngrove, CAN650SEStone Archer LLC · Hempstead, TXN650TThompson Matt · Shawnee, KSN650VVMindy Limited LLC · Muscatine, IAN650VXOneal Timothy James · Vancouver, WAN65107Renforth Michael E · Yorktown, VAN6510JSabin Michael J · Virginia Beach, VAN6510LPurpose Flight Inc · Wilmington, DEN6510TLenkersdorfer John D · Burley, IDN6511GBuerk James R · Smethport, PAN6511JCalhoun John R · Baton Rouge, LAN6511PCaplinger James F · Battle Ground, WAN6511TAgricola Joseph D · Brooksville, FLN6511VSc Skywalker Aviation LLC · West Sacramento, CAN6511WWinkler Frank · Joplin, MON6512DCajun Wings LLC · Bourg, LAN6512HOrganization Of Black Aerospace Professionals Inc · Olive Branch, MSN6512JDion Nelson · Cromwell, CTN6512KLoomis Aviation LLC · Columbus, OHN6512UWilliams Larry M · Midland, NCN6512WBirrer Urs P · Huntington Beach, CAN6513CZorn Tony P · Lyons, GAN6513DGhia Flying Venture LLC · Scottsdale, AZN6513JAlexander Sam L · Fair Play, MON6513TReilly Michael G · Somerset, NJN6513UKendall Keven S · Logan, UTN6513WBuss Dillon W · Pryor, OKN6514JJuggernautaviation LLC · Lewes, DEN6514RParker Scott L · Galatia, ILN6514WDickey Jacob L · Sandy, UTN6515South Dakota Aviation Hall Of Fame · Spearfish, SDN6515UFuller Spencer A · Lake Balboa, CAN6515WFrank Eric C · Frankfort, INN6516JTeresurv Corp · Port Saint Lucie, FLN6516PSchneringer Mitchell G DBA · Fremont, NEN6516WWalker Clint H · Tyler, TXN65173Boucher John C · Lakeside, AZ
Back to AD 87-10-06 R1