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.
N66710Big Bend Community College · Moses Lake, WAN6671ABurke John E · Spring, TXN6671JRotor And Wing LLC · Tioga, NDN6671PLunn Frank Paul III · Chatham, NHN6671RSmith Edward J · Sweet Valley, PAN6671UWizard Ventures Inc · Wilmington, DEN6671WSessions Max R · Moody, ALN66720Erickson Kirk E · Warroad, MNN6672AVandenbark Cody M · Troy, IDN6672HDavenport Thomas C · Buchanan Dam, TXN6673JMoody Edward L Jr · Candler, NCN6673WCk Nickels Inc · Muleshoe, TXN66740Wasik Richard C · Frankston, TXN6674LPurkinje Ltd LLC · Wilmington, DEN6674RLechner Mark J · Sault Sainte Marie, MIN6675JReece Aviation LLC · North Clarendon, VTN6676JRozof Chester F · Fort Myers, FLN6676RJackson Michael W · Bedford, TXN6676WWorkman Industries Inc · Durant, IAN6677HPeterson Robert E · Richland, WAN6677WOsgood Darrell F · Watervliet, MIN6678FAircraft Guaranty Corp Trustee · Oklahoma City, OKN6678JWiener Ronald K · Tucson, AZN6678WMadison Andrew J · Inver Grove, MNN6679UKimbrough Edward W · Houston, TXN667ABlaschka Michael T · Medford, ORFirst renewal noticeN667BAAmendala Brian R · Hillsboro, ORN667CRKnieling Gene A · Rush Center, KSN667LBChristiansen Aviation LLC · Wilmington, DEN667LDLeading Edge Aviation LLC · Manchester, MON667QTevik Michael A · Provo, UTN667SCSpartan Education LLC · Tulsa, OKN667SPHindi David · Cupertino, CAN667TCT J Aviation LLC · Kennesaw, GAN6680EPrax Philip · Fairbanks, AKN6680JElliott Bryn · Blue Point, NYN6680RWestlake Mark A · Jewett, OHN6681UGriffin Josh R · Minot, NDN6681XSky Harbor Aviation LLC · Powder Springs, GAN6682LDeyo Kenneth F · Thomaston, CTN6682RCavazos Jose Luis Jr · Houston, TXN66836Wolgemuth Jim · Anchorage, AKN6683UReisner Kenneth D · Lecompte, LAN66842Gelvin Stanley M · Central, AKN6684KMaslar Joseph P · Houston, TXN6684RRoberts Alec · Boulder, CON6684UFowler Kenneth G · Newport, TNN6684WWaltman Richard Dean · Moses Lake, WAFirst renewal noticeN6685UMccroskey Wesley D · Kingston, TNN6685WZulueta David · Louisville, GA
Back to AD 90-04-06 R1