Skip to content

Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N8416XBas Part Sales LLC · Greeley, COS/N 17248916 N8416ZSwamp Fox Aviation LLC · Chapin, SCS/N 205-0416 N84170Follmer Todd F · Dunwoody, GABuilt 1969 · S/N 17258364 N8417UPeninsula Aero Technology Inc · Kenai, AKBuilt 1964 · S/N 17252317 N84183Chickadee Aviation LLC · Burr Ridge, ILBuilt 1969 · S/N 17258368 N84185Harrison Gene R · Pendleton, ORS/N 17258348 N84186Gould George Jr · Bryantville, MABuilt 1969 · S/N 17258369 N8418GBravo Charlie Global LLC · Kalispell, MTBuilt 1965 · S/N 15062518 N8418SSwanson Scott R · Sulphur Springs, TXBuilt 1965 · S/N 18256518 N8418TAmes Jimmy M · Collinsville, OKBuilt 1959 · S/N 52318 N84190Frs & Craig Llp · Byron, GABuilt 1969 · S/N 17258371 N84193Smirnov Alexei · Fair Lawn, NJBuilt 1969 · S/N 17258372 N84194Ultra Aviation LLC · Cedar Bluff, VABuilt 1969 · S/N 17258373 N84195Norcal Flight Center LLC · Lincoln, CABuilt 1969 · S/N 17258374 N8419TSummers Greg D · Sheridan, ORBuilt 1959 · S/N 52319 N8419USweeney Building Co · Lakeview, ORS/N 17252319 N8419ZMahal Pradeep S · Warren, NJBuilt 1963 · S/N 205-0419 N841BMescalero Aviation LLC · San Antonio, TXBuilt 1967 · S/N R172-0220 N841DPSior David · Connelly, NYBuilt 1953 · S/N 16112 N841JARicci Theodore J · Spotswood, NJBuilt 1968 · S/N 17256902 N841JLMarks Stephen M · Monument, COBuilt 1967 · S/N T210-0330 N841JWScenic Concepts LLC · La Crosse, WIBuilt 1974 · S/N 17264340 N841RQMueller Steven L · Osceola, WIBuilt 1976 · S/N U20603273 N8420LHayhurst Shane R · Winfield, PABuilt 1968 · S/N 17256620 N8420MNapier Kelly L · Linton, INS/N A1500120 N8420SBrackett Scott S · Kingman, AZS/N 18256520 N8420ZWilkerson Thomas R · Kent, WABuilt 1963 · S/N 205-0420 N84210Pm Jets LLC · Ashland, OHBuilt 1969 · S/N 17258380 N84214Planefully Obvious LLC · Oshkosh, WIBuilt 1969 · S/N 17258382 N8421TKammann Trevor R · Wellton, AZBuilt 1959 · S/N 52321 N8421USky Falcon LLC · Syracuse, NYS/N 17252321 N8421ZSchmitt Rudy · Brookshire, TXBuilt 1963 · S/N 2050421 N84221Mcknight Michael D · Marietta, GABuilt 1969 · S/N 17258384 N84224Cordes Jeffrey A · Happy Valley, ORBuilt 1969 · S/N 17258386 N84225Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17258387 N84226Jackson County Aviation LLC · Sneads, FLBuilt 1969 · S/N 17258388 N84229Langenbahn Theodore John · Schoharie, NYBuilt 1969 · S/N 17258389 N8422LHubert Kim J Trustee · Eagle River, AKBuilt 1968 · S/N 17256622 N8422SPhoenix Innovations Inc · Scappoose, ORBuilt 1965 · S/N 18256522 N8422TCrutchfield Utility Aviation LLC · Siloam Springs, ARBuilt 1959 · S/N 52322 N8422XDundee Flying Club Inc · Rock Stream, NYBuilt 1961 · S/N 17248922 N8422ZN8422z LLC · Farmington, NMBuilt 1963 · S/N 205-0422 N84234Mazelg Aviation LLC · Bartow, FLBuilt 1969 · S/N 17258390 N84239Wells Richard M · Hartford, KYBuilt 1973 · S/N 18261857 N8423GCamp Derek E · Sweetwater, TNBuilt 1965 · S/N 15062523 N8423LYoung James A · Toledo, WAS/N 17256623 N8423SPatton Steven R · Wayne, OHBuilt 1965 · S/N 18256523 N8423ZCox Ronald A · Poplar Grove, ILBuilt 1963 · S/N 205-0423 N84243Sjoberg Donald E · Poteau, OKBuilt 1969 · S/N 17258393 N8424LMcgreen John R · Albany, NYBuilt 1968 · S/N 17256624

Back to AD 87-20-03 R2