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.
N9147THoiles Richard C · Shortsville, NYN9147VN206ht LLC · Pulaski, IAN9148GCheutin Didier V · Orlando, FLN9148JNovember Nine One Four Eight Juliet LLC · Fulton, MON9148SBlue Skies Aviation LLC · Holland, MIN9149JJones Lynn · Birmingham, ALN9149QCovington James A · Huntsville, ALN9149SBurnard Russell J · Seward, AKN914ADDepinet Andrew P · Galion, OHN914AZN969az LLC · Miami, FLN914DSaker Air LLC · Charlotte, NCN914ETrettin Anthony K · Mason City, IAN914GPRoy Dino · Saginaw, TXN914HMeadows Mark A · Mooresville, INN914HMMiesler Hans U · Penrose, CON914HPBonsey James E · Newberg, ORN914JDAis Wings LLC · Grand Rapids, MIN914JWWright John T · Jacksonville, FLN914PACoco Aircraft Inc · Merritt Island, FLN914RRMartinez Jeff L · Lewistown, MTN914SCole Thomas Ed · White Settlement, TXN914SWSilver Express Co DBA · Miami, FLN914THanley Stuart · Hollywood, FLN914VNewhouse Flying Service Inc · Fredericksburg, TXN914ZSkylens LLC · Hammond, LAN91507Eagle Aviation LLC · Spearfish, SDN9150DFitzgerald Larry · Fairbanks, AKN9150HN9150h LLC · Charleston, SCN9150VUrness John · Oakland, CAN91518Hatfield Timothy E · Parowan, UTN9151HFirst Flight Corp · San Diego, CAN9151LCerrato Michael J · Dublin, OHN9151NPlane Nonsense Inc · Middletown, DEN9151VNeret Michael G · Sugarland, TXN9151YRegistration Pending · South Jordan, UTRegistration pendingN9152KHangar 9 Inc · Aberdeen, SDN9152LBaker Glen M · El Reno, OKN9152SHomer Mark · Grosse Ile, MIN9153HSambriski Michael Daniel III · Long Beach, NYN9153SB Squared Inc · Bedford, NHN9153VRegistered aircraftN91544Piper Aircraft Inc · Vero Beach, FLN91553Simpson Josiah J L Trustee · Shelburne, MAN9155DTaylor Glenn Maurice · Fayetteville, GAN9155VHickox Joseph C · Rollins, MTN9156DTalmadge Jeffery K · New Milford, CTN9156HSolar Flying Club · Grimes, IAN9156JChristian Family Fellowship · Mesa, AZN9156SStickley Harold R · Wauseon, OHN9156VLegnaioli Richard · Cambridge, MD
Back to AD 90-04-06 R1