Registered aircraft · 3,961

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-21-02-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-21-02-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-21-02-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-21-02-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-21-02-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-21-02-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.

N7549QAlford Air Transportation LLC · Kernersville, NCBuilt 1972 · S/N 421B0341 N754JSDy34 LLC · Adamsville, TNBuilt 1975 · S/N 414-0643 N754KCPlane Crazy Aviation LLC · Fargo, NDBuilt 1981 · S/N 414A0803 N7552QTaylor Randy L · Upland, CABuilt 1969 · S/N 310Q0052 N7554QSky Farmer LLC · Culleoka, TNBuilt 1970 · S/N 310Q0054 N7556QKent Schreiber Company · Greencastle, PABuilt 1972 · S/N 310Q0604 N7557QCircle C Aviation LLC · Orlando, FLBuilt 1972 · S/N 421B0345 N755ACAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402A0001 N755BCMav Management LLC · Rockledge, FLBuilt 1978 · S/N 421C0497 N7564QFairchild Chad E · Logandale, NVBuilt 1970 · S/N 310Q0064 N7568QJughead Aircraft LLC · Salina, KSBuilt 1970 · S/N 310Q0068 N757CAKenyon Walter C · Eureka Springs, ARBuilt 1972 · S/N 310Q-0535 N757RHPanther Partnership Equipment I LLC · Gibsonton, FLS/N 421C1049 N7584QArnold Brandon M · Roswell, NMBuilt 1970 · S/N 310Q0084 N7586QTyler Rdh Investments LLC · Tyler, TXBuilt 1970 · S/N 310Q0086 N7589QTemptation Motors Ltd · Hayward, CABuilt 1970 · S/N 310Q0089 N758DCSale Reported · Altoona, FLSale reportedBuilt 1972 · S/N 310Q0471 N759JSIsland 414 LLC · St Simons Island, GAS/N 414-0936 N75CBEastmann Transport Services LLC · El Paso, TXBuilt 1975 · S/N 421B0861 N75GBPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1975 · S/N 402B0912 N75SKRick Broke Entertainment LLC · Conyers, GABuilt 1974 · S/N 421B0646 N75TTReisback Scott · Olalla, WAS/N 414A0405 N7600QTwin D LLC · Lake City, FLBuilt 1973 · S/N 310Q0781 N7602QKbg Air LLC · Deerfield Beach, FLBuilt 1970 · S/N 310Q0102 N760RMAircraft Partner Holdings Inc Trustee · BerlinBuilt 1975 · S/N 414-0815 N7624QFhs Aero Co · Olathe, KSBuilt 1973 · S/N 421B0363 N7626QSnap Roll Enterprises LLC · West Chester, OHBuilt 1970 · S/N 310Q0126 N762CACullum Transportation LLC · North Charleston, SCBuilt 1981 · S/N 421C1214 N762TBAero Crafter LLC · Miami, FLBuilt 1977 · S/N 421C0213 N7632QPremier Helicopters LLC · Carson City, NVBuilt 1973 · S/N 340-0236 N7638QGunder Austin C · Red Lion, PABuilt 1971 · S/N 310Q0418 N763EAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0497 N763JCPilot Services Of Ohio LLC · Loveland, OHBuilt 1976 · S/N 421C0211 N7644QSmith Carl D · Durham, NYBuilt 1971 · S/N 310Q0423 N764EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0237 N764PBBisono Pablo R · Guaynabo, PRS/N 402C0338 N7651QAmerican Academy Holdings Inc · Stanford, CAS/N 310Q0430 N7652QBoone Aviation LLC · Valdosta, GABuilt 1971 · S/N 310Q0431 N7658QRamos Mario · Anaheim, CABuilt 1972 · S/N 310Q0437 N765FLAviation Angel Tours LLC · Beverly Hills, CABuilt 1975 · S/N 414-0644 N765JBN765jb LLC · Colorado Springs, COS/N 340A0647 N765LTDrj Aviation LLC · Dover, DES/N 340-0181 N7661QCooper Kenneth E · Whiting, INBuilt 1971 · S/N 310Q0440 N7664QDluhos Robert A · Hilton Head, SCBuilt 1971 · S/N 310Q0443 N7667QBergenty William F DBA · Plainville, CTBuilt 1972 · S/N 310Q0446 N7668QRiester Robbin W · Navarre, FLS/N 310Q0447 N7670QRivers Willie G · Atlanta, GABuilt 1972 · S/N 310Q0449 N7678QEshowe Aviation Inc · East Peoria, ILBuilt 1972 · S/N 310Q0457 N767RRRed Leasing LLC · Juneau, AKBuilt 1972 · S/N 310Q0455 N767ZRubin Broadcasting Inc · Dallas, ORS/N 421C0401

Back to AD 87-21-02 R1