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.
N5663WCrane Air LLC · Waterford, MIN5664HPierce Stephan L · Graham, TXN56651Boettcher Kurt · Julian, CAN56652Carpenter Stephen K · El Paso, TXN56658American Aviation Inc · Brooksville, FLN56659Skoog Timothy Mark · Monroeville, PAN5665PLangevin Michael · Anchorage, AKN5665UZimmerman Damian P · Petersburg, ILN5665VWanigas Leasing Corporation · Saginaw, MIN5665ZPerez John-Henry · Locust Grove, GAN56668Pendarvis Damon E · Morrow, OHN5666PChrysoar Group LLC · King George, VAN5666ZWheeler James R · Falling Waters, WVN56676Paris Air Inc · Vero Beach, FLN56679Worthington Brian M · Saint Albans, NYN5667HLeader Russell J · Glasgow, MTN5667QLove Phillip Love · Rib Mountain, WIN5667SParsons John C · Wichita, KSN5667WBartanowitz Frank · Millwood, GAN56680Sky III Corporation · Smyrna, TNN56682Hogan David · Simpsonville, SCN56686Paris Air Inc · Vero Beach, FLN56690Shreeve Michael W · Port Orange, FLN56694Bruce Robert · Ormond Beach, FLN56695Wassell Aviation LLC · Irwin, PAN56696Sterling Oliver James III · Hancock, NHN5669DMurphey Julian R · Knoxville, TNN5669HUsaviation.Com LLC · Moorestown, NJN5669LGallien Justin A · Livermore, CAN5669NLynn Martin K · Brownsboro, ALN5669PPueringer Matthew B · Britt, MNN5669QMills James A · Dearborn, MIN5669URollins Seth B · Smithville, MSN566BGN566bg LLC · Leesburg, VAN566BSSand Farm Management Services LLC · Adel, IAN566FLSarem Daniel J · Spencerville, MDN566JHRadel Richard L Jr · Bloomsburg, PAN566KAtp Aircraft 3 LLC · Wilmington, DEN566MTMiddle Tennessee State University · Murfreesboro, TNN566QButte Aviation Inc · Butte, MTN566RCJacques Adam P · Weirsdale, FLN566RVCary Steven B · Brookshire, TXN566SPLlp Leasing Group LLC · Lewes, DEN56701Eros Aviation Ventures LLC · Oakland Park, FLN56703Arthur Gerald J · Riverside, CAN56704Anderson Aviation LLC · Wadesboro, NCN56705Syrek William · Erie, PAN5670HMatyas Joseph J · Drums, PAN5670LCranford Julian Edward Jr · Lexington, NCFirst renewal noticeN5670QMiller Steven J · Fresno, TX
Back to AD 90-04-06 R1