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.
N738ZNRobins David B · Lander, WYN738ZQRieman Joel · Lompoc, CAN738ZRFicus Point Aviation Corporation Inc · Middletown, DEN738ZTSp Airparts LLC · Moscow, IDN738ZUSkydance Aviation LLC · Chesapeake, VAN738ZYRegistration Pending · Syracuse, NYRegistration pendingN73900Dewey William B · Santa Barbara, CAN73904Vaayu Aviation LLC · Newark, CAN73905Fingerlakes Wing And Rotor LLC · Seneca Falls, NYN73907Denlinger Darin · Modesto, CAN7390JViets Richard C · Bloomer, WIN7390WRegistration Pending · Concord, NCRegistration pendingN7391Christopherson Jack T · Overgaard, AZN73910Arispe Aviation LLC · Mckinney, TXN73917Wingsleasing LLC · Wichita, KSN7391DJohnson Robert D Trustee · Anchorage, AKN7391JDenke Larry · Long Valley, SDN7391KLandry Matthew A · Soldotna, AKN7391LAbdulshafi Ahmed Jason · Oxnard, CAN7391WDippolito Mario M · Sherwood, ARN7391YAeronautical Technical Service Inc · Collierville, TNN73922Mouton Charles J Jr · Gladewater, TXN73923Professional Aviation Aircraft Services Ltd · New Philadelphia, OHN73924Mack Aviation Holdings LLC · Atlanta, GAN73925Wings Over Texas Holdings LLC · Denton, TXN73926Hatanaka Brandon C · Loveland, CON73927Abcd Ventures LLC · Ada, OKN73928Air Peanut Ltd · Wilmington, DEN73929Jprg Aviation Inc · Orlando, FLN7392J33 Global LLC · Potomac Falls, VAN7392LKnowles Charles M Jr · Chapmanville, WVN73930Bunke Paul R Trustee · Harrison, OHN73934Hanson Alexander P · Bremerton, WAN73938Preston Richard R Trustee · Albuquerque, NMN7393GBlue Wings LLC · Brecksville, OHN7393JSale Reported · Tyler, TXSale reportedN73946Carastro Enterprises LLC · Montgomery, ALN7395DAviation Management Group LLC · Endicott, NYN7395GBrewer James · Myakka City, FLN7395JOhm Aviation LLC · Wmca, NVN7395KDoty Brandon Charles · Debary, FLN7395LCatherines Aviation Services LLC · Sewanee, TNN7395PGroux Jeffrey S · Rome, GAN7395WHuckfeldt Owen D · Alliance, NEN73964Coachron Investments LLC · Grosse Ile, MIN7396JBurns Preston T · Spruce Pine, ALN7396WN7396w LLC · Coeymans Hollow, NYN7396YAllen Charles M · Puryear, TNN73974Triple F Flying Inc · Benton, PAN73977Bfl Aviation LLC · Bakersfield, CA
Back to AD 90-04-06 R1