Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N52840N52840 LLC · New York, NYFirst renewal noticeBuilt 1988 · S/N 24-1683 N5284UCochrane Timothy A · Chippewa Lake, OHBuilt 1964 · S/N U206-0284 N5285PFrank Investments Inc · Austin, TXBuilt 1996 · S/N 29-0081 N5285RPuddle Jumper Aviation LLC · Brighton, COS/N 18503027 N5285UShroyer Jayme D · Longmont, COBuilt 1964 · S/N U206-0285 N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349 N5287YMorrow Aviation LLC · Midland, TXS/N 21064152 N528EWNc Aviator LLC · Fuquay Varina, NCBuilt 1989 · S/N CE-1375 N528HEKingdom Airworks LLC · Las Vegas, NVBuilt 2005 · S/N 1409 N528PLebanon Air Taxi LLC · Hanover, NHBuilt 2004 · S/N E-3565 N528WARiley David P · South Barrington, ILBuilt 1979 · S/N P21000315 N5293BBas Part Sales LLC · Greeley, COBuilt 1996 · S/N 29-0080 N5293JWestsand Aviation LLC · Allegan, MIBuilt 1982 · S/N 414A0857 N5293XBaker Leasing LLC · Kotzebue, AKS/N U20605612 N5296AHobot LLC · Springdale, ARBuilt 1985 · S/N P21000847 N5296UMeyers Karl F · Tucson, AZRegistration revokedBuilt 1964 · S/N U206-0296 N5298UPatanapong Somboonsap · Oakland Park, FLBuilt 1964 · S/N U2060298 N529ADDcm Air LLC · Canton, MIBuilt 1980 · S/N P21000603 N529AJCaiazzo Leonard · Belle Harbor, NYBuilt 2004 · S/N 1242 N529CDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 1621 N529DDSchwertfeger Dean · Woodruff, WIBuilt 1970 · S/N D-9151 N529LHRightway Drywall Inc · Macon, GABuilt 2019 · S/N TH-2517 N529MKBlue Ryan LLC · Englewood, COBuilt 2005 · S/N 1590 N529SARaptorsair LLC · Mchenry, ILBuilt 2001 · S/N E-3429 N52AUUllman Aaron L · Barksdale Afb, LABuilt 1967 · S/N D-8484 N52CSBombs Away LLC · Elkins, ARBuilt 1974 · S/N 414-0615 N52GSLqp Aviation LLC · Gary, SDBuilt 1968 · S/N E-122 N52HCOak Bay Aviation LLC · Bellvue, WABuilt 1980 · S/N TJ-274 N52JRAg Tech Farm Services · Gamaliel, KYBuilt 1968 · S/N 421-0197 N52JVSl Leasing Group LLC · Atlanta, GABuilt 1973 · S/N 421B0459 N52KWFreedom Aviation LLC · Alexander, ARBuilt 2005 · S/N 29-0375 N52LGGroom Lincoln · Wadmalaw Island, SCBuilt 1991 · S/N CE-1627 N52MBRoark Dale L · Cheyenne, OKS/N TE-395 N52MMHappy Sky LLC · Brooklyn, NYS/N 21064870 N52PAOctagon Corp · Lewes, DEBuilt 1975 · S/N 310R0537 N52PCDitsch Craig · Hondo, TXBuilt 2001 · S/N LIV-152 N52PJJensen Paul · Highland Village, TXBuilt 2004 · S/N 0850 N52PTQualitair LLC Trustee · MichelstadtBuilt 2007 · S/N L2K-257 N52QTFly Qts LLC · Oconomowoc, WIBuilt 1973 · S/N 414-0480 N52RBHeights Multi Flight Management LLC · Monroeville, NJBuilt 1979 · S/N 414A0302 N52SBRedwood Oil Co Inc · Rohnert Park, CABuilt 1978 · S/N E-1274 N52SEPryor Jeff · Santa Barbara, CABuilt 1978 · S/N P21000080 N52TFAs The Crow Flies LLC · Belmont, WIBuilt 1998 · S/N 29-0154 N52TZTurley Dale R · Poway, CABuilt 1988 · S/N CE1297 N52WXGalaxy Drivers LLC · Dover, DEBuilt 1984 · S/N 468508011 N53000Mckinna Kiley J · Dakota Dunes, SDBuilt 2004 · S/N 0855 N53006Hemphill Holdings LLC · Hemphill, TXBuilt 1973 · S/N 18502312 N5300ARunzel Brothers Aviation LLC · Bensenville, ILBuilt 1979 · S/N 21063356 N53013Metzler Alan J · Reedsville, PABuilt 1973 · S/N 18502317 N5302VSniader David J · Miami, FLFirst renewal noticeBuilt 1975 · S/N 21060902

Back to AD 86-13-04 R3