AD 90-04-06 R1
Registered aircraft · 68,377
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
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.
N5024SGuy Timothy S · Henderson, NVN5024TMoore Jason J · Spanish Fort, ALN50259Coker Steve L III · Tyler, TXN5025CSamalon William S Trustee · Juneau, AKN5025DCal-Aerofab Flight Academy Inc · Chino, CAN5025EStokes Field LLC · Mount Vernon, MON5025FAllen Scott L · Ogallala, NEN5025MRezich Nicholas R · Green Bay, WIN5025PFoley Jeffrey W · Scappoose, ORN5025QAppel Joshua D · Redfield, SDN5025SAir Cover Academy LLC · Frankford, MON5025TRoney William A · Santa Fe, NMN5025UDuke Michael R · Mc Gregor, TXN5025ZDean Charles William III · Boyle, MSN50264Hooper Kenneth R · Hermitage, TNN5026BLaurie Craig M · Anchorage, AKN5026ETurner Greg W · Delta Junction, AKN5026FRegistration Pending · Greenville, NCRegistration pendingN5026GJohnson Steven L · Salol, MNN5026KGriswold David M · Port Townsend, WAN5026NWright Bruce M · Rosharon, TXN5026RSwinney Marty Sherman Trustee · Macomb, OKN5026SSchwenker Jerry D · Maquoketa, IAFirst renewal noticeN5026WSpencer Don W · The Dalles, ORN5026ZBrown Robert C III · Whiteville, NCN50271Sawyer Johnson Inc · Osceola, WIN5027FAmoia Steven M · La Mesa, CAN5027KMchale Thomas Alexander II · El Paso, TXN5027NMargolin Donald B · Santa Barbara, CAN5027RVentura Hector E · Vieques, PRN5027SRatliff Thomas E · Tomball, TXN5027TMohre Steve G · Blakeslee, OHN5027WJohnson Dennis E · Factoryville, PAN5028FMarshall Kevin · Dekalb, ILFirst renewal noticeN5028GButler Patrick F · Elko, NVN5028LBarla Joel · Eaton Rapids, MIN5028SSmith David J · Elkhart, INN5028TDrake Charles R · Claremore, OKN5028VFlying Lemur Inc · Alexandria, VAN5028ZRegistered aircraftN50291Euros Aircraft Leasing LLC · College Station, TXN5029ETimmins Christian · Covington, LAN5029GArnold Michael P · Boise, IDN5029KFerrin Aviation LLC · Rome, GAN5029SChop Bert D · Oak Grove, LAN5029WJaycor Foundation · Buirr Ridge, ILN5029ZSvec Adolph Ralph · Marengo, ILN502DWSolamich Aviation LLC · Huntley, ILN502FLBeasley James L · Abilene, TXN502GLSky Dancing LLC · La Jolla, CA
Back to AD 90-04-06 R1