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.
N75048Southern Aircraft Consultancy Inc Trustee · Casper, WYN75049Christie Brian L · Irvine, CAN7504FDerr Michael K · Maitland, MON7504HSmokovitz Tyler · Fenton, MIN7504SAirczar LLC DBA · Corpus Christi, TXN7504VImage Craft LLC · Phoenix, AZN7504WThompson Reese F · Lake Stevens, WAN75050Delaware State University · Dover, DEN75055Registered aircraftN75056Warwick Kenneth Robert · Estill Springs, TNN75057Gunter Jerry L Sr · Huntersville, NCN75058Russell K C · Lindsay, CAN75059Markiewicz Mark J · Kokomo, INN7505BSilver Wings Inc Trustee · Wilmington, DEN7505DCronan Joseph M · Santa Maria, CAN7505FIpme Management Corp · Jefferson, GAN7505RMil2atp Inc · Pikeville, NCN7505VSky West Aviation Inc Trustee · Albuquerque, NMN75068Kinzie Industries Inc · Erie, COExpired dealerN7506FOklahoma Airmen Flying Club Inc · Jenks, OKN7506KHaugh Darin · Fairbanks, AKN7506NMeshoppen Air LLC · Tunkhannock, PAN7506RGleason Joseph G · Gainesville, FLN75070Mansfield Heliflight Inc · Milton, VTN75078Gibson Elizabeth Grace · Hamilton, NJN7507CBlair & Son Inc · Fleetwood, PAN7507FThomson Mary Ellen · East Berlin, PAN7507GEmerald City Aircraft Leasing Inc · Port Orchard, WAN7507MWeststar Ventures LLC · Cannon Falls, MNN7507NKinzie Hon · Anchorage, AKN7507RPanko Douglas A · Minooka, ILFirst renewal noticeN7507USierra Sky Aviation LLC · Kalispell, MTN75080Dix Jeffrey G · Wausau, WIN75082Up And Away Aviation LLC · Poughkeepsie, NYN75084Wadas Burton J · Hudson, NHN7508HSons Aviation LLC · Moody, ALN7508KRegistered aircraftN7508LBruegger Shannon B · Lance Creek, WYN7508RTaylor Devan A · Overland Park, KSN75093Turner Barry D II · Mccook, NEN75095Smith David Ross · Greensboro, NCN7509DPiggott Philip W · Peru, INN7509MFerry Douglas W · Santee, CAN7509PSuperbird Aviation LLC · Atlantic, IAN750CZBinder Douglas B · Ithaca, NYN750DAParkhill Lawrence · Ojai, CAN750DS5 Pm Inc · Nampa, IDN750FYShuck Matthew M · Merrill, ORN750HKRegistration Pending · Lutz, FLRegistration pendingN750KOgk Aviation LLC · Mandan, ND
Back to AD 90-04-06 R1