AD 90-04-06 R1
Registered aircraft · 68,369
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.
N184GCLacher Robert E · Louisville, KYN184GLLippincott Jay · Highlands Ranch, CON184JDRegistered aircraftN184JLPeters Bryan · Corpus Christi, TXN184KXClerf Craig R · Ellensburg, WAN184MAShelby Ronnie F · Comanche, OKN184MHRenner Robert C · Erie, PAN184NFBoback Thomas J · Coppell, TXN184PHEbhs LLC · Monroe, MIN184PYCoggin Patric D · Fort Smith, ARN184RBBeverly Raymond E · Eugene, ORN184RFGreens Effects Inc · Moorpark, CAN184RJFarmer Gary W · Mount Juliet, TNN184RMPumpkin Seed Aviation LLC · Wilmington, DEN184RVAir O Enterprises · Hospers, IAN184SCChristiansen Robert S · Rapid City, SDN184TSpaur Charles W · Aurora, CON184TCTexas State Technical College · Waco, TXN184TSSanders David M · Midlothian, VAN184TWEvans William Patterson II · Dallas, TXN184WBAnthony L Krause · Brentwood, MON184WFSitkiewicz James P · Anchorage, AKN184WLNastro Kristopher J · Fallon, NVN1850AWells Kris G · Barron, WIN1850GMadison Nicholas R · Fayette, ALN1850NSnohomish Flying Service Inc · Snohomish, WAN1850PPeters Nicholas J · Eagle River, AKN1850QVincz Shawn · Williams, INN18510Moore Jack B · Irvine, CAN18516Maine Instrument Flight · Augusta, MEN18518Sale Reported · Waterbury, CTSale reportedN1851JSande 6 Aviation Inc · Wilmington, DEN18523Km50 Ventures LLC · Pensacola, FLN18529Briers Scott Kevin · Conroe, TXN1852JHanneman Robert · Denver City, TXN1852MCundiff Charles Lee · Canby, ORN1852PBennack George H · Lyford, TXN1852QTalbot Mitchell R · Queen Creek, AZN1853JSargent David W · Port Angeles, WAN1853MVajdos Robert C Jr · Louise, TXN1853PViersen Leonard J Trustee · Glennallen, AKN18541Bender Jace Ef · Humphrey, NEFirst renewal noticeN1854BAdams Samuel M · Anna, TXN1854JM & D Aviation 2019 LLC · Ocklawaha, FLN1854QSc Cardinal LLC · Wilmington, DEN1854VSchmitt Rudy · Brookshire, TXN1855AMoore Brandan D · Wasilla, AKN1855JNicholson John · Sapulpa, OKN1855PBpdk LLC · Mason, MIN1856JWood Dragon LLC · Portland, MEFirst renewal notice
Back to AD 90-04-06 R1