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

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

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.

N46736Krantz Gwendolyn A · Advance, NCBuilt 1968 · S/N 17257460 N46737Berney John E · Morgan Hill, CABuilt 1968 · S/N 17257461 N4673RBall Dontel J · Tacoma, WABuilt 1966 · S/N 28-21430 N46742Barlet Richard D · Carthage, MOBuilt 1968 · S/N 17257463 N46743Longino Thomas G · Celeste, TXBuilt 1968 · S/N 17257464 N46744Harrison Airplane LLC · Cynthiana, KYBuilt 1968 · S/N 17257465 N46746Dunlap Gary P · Seattle, WABuilt 1968 · S/N 17257466 N4675JRegistration Pending · Gardnerville, NVRegistration pendingBuilt 1968 · S/N 28R-30576 N4675RLatham Cary · Hardin, KYBuilt 1966 · S/N 28-21432 N46760Caterinichio Gasper D · Eagle River, AKBuilt 1954 · S/N 18-3907 N4676FSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7715059 N4676PHuslig Brandon M · Carefree, AZBuilt 1960 · S/N 27-205 N46775Lookner Augustus · Owls Head, MEBuilt 1954 · S/N 18-3594 N4677RFields Michael L · Rockwood, TNS/N 28-21434 N4678PRudloff Uwe K Trustee · Lake Village, INS/N 27-207 N4678RRegistration Pending · Vadnais Heights, MNRegistration pendingS/N 28-21436 N4678TRothberg Diane Lee · Gainesville, GABuilt 1981 · S/N R18201730 N4679GFlightime Inc · Elkhart, INS/N 17273305 N4679HAdams Kris · Griffin, GABuilt 1979 · S/N 24-0808 N4679WBravo Whiskey LLC · Cascade, COBuilt 1978 · S/N 13255 N467AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843741 N467AT467at LLC · Frankfort, ILBuilt 1968 · S/N 17700879 N467CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280859 N467DKRegistered aircraftBuilt 1995 · S/N 467 N467FAMain Line Flight School LLC · Haverford, PABuilt 2022 · S/N 28020067 N467GRRoach Gene T · Frankfort, KYS/N 892 N467HABuell Travis · Harper, TXBuilt 2001 · S/N 0984 N467PEOkane James K · Noblesville, INBuilt 2013 · S/N 1 N467QStegner John J · Boonville, MOBuilt 1976 · S/N 17266649 N467TFHarts Joel D · Coffeyville, KSBuilt 1995 · S/N 1 N468Downs Daniel D · Phoenix, AZBuilt 1982 · S/N 7417C N4680JCorral Oscar L · Ft Stockton, TXS/N 350 N4680RGibbs Robert I · Ravenswood, WVBuilt 1966 · S/N 28-21439 N4681JRose Jeffrey R · Niceville, FLS/N 28R-30581 N4681SRezek William E · Centennial, COBuilt 1979 · S/N R18201377 N46828Petro Jerry R · Williamsburg, VABuilt 1953 · S/N 2009 N4682DBusch Craig D · Green Brook, NJBuilt 1979 · S/N 17272330 N4682JAhz Aviation LLC · Shawnee, KSBuilt 1968 · S/N 28R-30561 N4682RTremblay Stanley R Sr · Dexter, MEBuilt 1966 · S/N 28-21441 N4683STorley Christopher · Flower Mound, TXBuilt 1979 · S/N R18201378 N4683TBatchelor William · Sicklerville, NJBuilt 1972 · S/N 28-7225199 N4684CSmith Cameron T · Placitas, NMBuilt 2008 · S/N 68 N4684JByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28R-30585 N4684TMk Aviation LLC · Charlotte, NCS/N R18201733 N4685JGaither William W · Shallotte, NCBuilt 1968 · S/N 28R-30586 N4685TMalagrifa Richard · Swampscott, MABuilt 1981 · S/N R18201734 N4686VRegistration Pending · Patterson, LARegistration pendingS/N 172RG0365 N4687JPletcher Enterprises Inc · Muscatine, IABuilt 1968 · S/N 28R-30589 N4687RMontz Steven Andrew · Mandeville, LABuilt 1966 · S/N 28-21448 N4687SP & V Howard Enterprises LLC · Angleton, TXBuilt 1979 · S/N R18201380

Back to AD 87-10-06 R1