Registered aircraft · 68,375

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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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.

N360WSWood Scot L · Irvington, ALBuilt 2014 · S/N 1482 N360WY360wy LLC · Pinedale, WYBuilt 2014 · S/N BC21405001 N360XKPoore Curby W · Mcdonald, KSS/N 435-320-185 N360XPBaker Laurence Todd · Imlay City, MIBuilt 1990 · S/N 566 N360XSFoster Aviation And Mobile Maintenance LLC · Dublin, VABuilt 2002 · S/N 908 N360XTThorall Patrick A · Chugiak, AKBuilt 2023 · S/N PT003 N360YBBeato Ronil · Plant City, FLBuilt 2019 · S/N 510-320-248 N360ZRN360zr LLC · Jacksonville, FLBuilt 1999 · S/N 749320591FB N36102Gallodoro Dolores M · Prattsville, NYBuilt 1941 · S/N 3069 N3610ADid U Die Inc · Herrin, ILBuilt 1953 · S/N 22-1870 N3610HScheffing Glenn J · Palm Beach Gardens, FLBuilt 1977 · S/N 20-1246 N36115Turner Randall D · Tolar, TXBuilt 1978 · S/N 28-7816613 N36116Meriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816614 N36118Cg Aviation LLC · Woods Cross, UTFirst renewal noticeBuilt 1978 · S/N 28-7890495 N3611HTavalaro Joseph DBA · Massapequa, NYBuilt 1977 · S/N 20-1247 N3611MPozanac Charles J · Riverside, CABuilt 1947 · S/N 12-2543 N3611NDowden Frank D · Fallbrook, CABuilt 1967 · S/N 680010 N36120United States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837266 N3612PGoundry George D · Sammamish, WABuilt 1955 · S/N 22-3338 N36134Manning John W · Floyds Knobs, INBuilt 1978 · S/N 28-7816615 N36137Big Bend Community College · Moses Lake, WABuilt 1973 · S/N 542-73 N36138Smith Brian Lee · Solvang, CABuilt 1973 · S/N 382-73 N36139Flying Sportsmen Inc · Sussex, NJBuilt 1973 · S/N 105-73 N3613AWarren Charles J · Sarver, PABuilt 1953 · S/N 22-1873 N3613MHall Gary L · Delta Junction, AKBuilt 1947 · S/N 12-2459 N3613NBradbury Kevin Earl · Saint George, UTBuilt 1967 · S/N 680011 N3613PLittle Bear Air LLC · Lubbock, TXS/N 22-3339 N36140Phillips James M · Wilmington, NCBuilt 1973 · S/N 957-73 N36141Averill Terry B · Litchfield, MEBuilt 1973 · S/N 544-73 N36147Goldsborough Darryl S · Coatesville, PABuilt 1954 · S/N 3126 N3614QMay Robert L · Spring Branch, TXBuilt 1967 · S/N MB-252 N3614RKrautschun Bart · Spearfish, SDS/N 28-5710 N3614XPanther Enterprises LLC · Fort Myers, FLS/N 5090 N36157Conn Philip J · Robins, IAS/N 3136 N36159Mondik James A · Palm Beach Gardens, FLBuilt 1941 · S/N 3138 N3615MRenfro Michael W · Bethel, AKBuilt 1947 · S/N 12-2461 N3615NWalker Eric L · Southlake, TXBuilt 1967 · S/N 680012 N3615QPlane Safe Aircraft Maintenance Inc · Waukesha, WIS/N MB-237 N36167James Brett · Louisburg, NCBuilt 1978 · S/N 28-7890497 N36168Sale Reported · Augusta, GASale reported, canceledS/N 3176 N3616ARegistration Pending · Safford, AZRegistration pendingS/N 22-1876 N3616MPrince Benjamin D · Lincoln, MTBuilt 1947 · S/N 12-2462 N3616NDe Masters Jasper · Bakersfield, CABuilt 1967 · S/N 680013 N3616PKidd Myles · Machesney Park, ILBuilt 1955 · S/N 22-3344 N36173Schuster Darin D · New Castle, DEBuilt 1973 · S/N 546-73 N36174Meise Fred W · Moses Lake, WABuilt 1973 · S/N 958-73 N36176Otte Duane P · Plainfield, INBuilt 1973 · S/N 101-73 N36178California Flyers Training Solutions LLC · Sun City, CABuilt 1973 · S/N 383-73 N3617PPhilpott Gary D · Camden, SCBuilt 1956 · S/N 22-3723 N36187Swaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816619

Back to AD 90-04-06 R1