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.
N624CECertified Equipment Inspections LLC · Washington, PAN624CJJones Steven Clark · Flagler Beach, FLN624DGRv4 Adventures Inc · Wilmington, DEN624FTFlorida Institute Of Technology · Melbourne, FLN624HNeed For Speed Inc · Dover, DEN624JTStandhart Gary · Wickenburg, AZN624MCStauffer Mark A · Appleton, WIN624MMLee Douglas A · Truckee, CAN624MSMcclure George E Jr · Nipomo, CAN624NDZaki Amir S · Orangevale, CAN624PAGeneral Aviation LLC · Henderson, NVN624RCJeffrey Guy · Centerburg, OHN624SStoro Eddy · Netarts, ORN624SEPrysi Mary H · Dundee, OHN624TCArnaoutis Antonios D · Ormond Beach, FLN624TFDominy Kenneth W · Ave Maria, FLFirst renewal noticeN62502Hill Andrew T · Smithville, TXN62503Back Forty Flying Club Inc · Roanoke, INN62506Stevenson George Otis · Wheatland, WYN6250CShields Ray Winfrey III · Marietta, GAN6250NOver The Top Aviation Inc · Jonesboro, ARN6250UAsb Jones Aviation · Uniontown, OHN6250WCummings Property Restoration LLC · Bullard, TXN62511Dezee Matthew J · Corinth, KYN6251JGamache Bernard J · Yakima, WAN6251LDavis William Ray · Cypress, TXN6251QGabel Glenda · Eureka, CAN62527Flybarely LLC · Manitowoc, WIN62529Turner Benjamin G · Lagrangeville, NYN6252DH & H Aviation Enterprises LLC · Fairfield, OHN6252LHaynes Larry C · Troutman, NCN6252UBrown Joshua W · Pomona, ILN6252WBas Part Sales LLC · Greeley, CON62530M And M Club Inc · Manakin Sabot, VAN62531Lg Holdings LLC · Gretna, NEN62536Shearer Eric · Manassas, VAN62547Executive Air Taxi Corp · Bismarck, NDN6254DSeventy Seven Industries LLC · Waddell, AZN6254JCoast Flight Training And Management Inc · San Diego, CAN6254UDavis Steven Lynn · Hebbronville, TXN6254VVector Air Inc · Oklahoma City, OKN6254WHayes George L · Longmont, CON62550Jones Robert N Trustee · Palmer, AKN6255DBowdidge Jeffrey E · Kingwood, TXN6255UMcclure Garnet · Frankston, TXN6255WCrumpler Stephen M Jr · Smithfield, NCN6256CKing David M · Plainville, CTN6256GIlmberger Stephen J · Bend, ORN6256LGuy Jon C · Margate, FLN62572Bendock Terry · Grants Pass, OR
Back to AD 90-04-06 R1