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.
N84350Piecko Michael T · Genoa, ILN84351Stanton James W · Maple, NCN84352Boundless Aviation LLC · Kailua Kona, HIN84358Child Michael A · Fort Worth, TXN8435DOrbis Advisory Services LLC · Hebron, KYN8435EZeller Ray G · Brookings, ORN8435FRed Tail Scholarship Foundation · Tuskegee, ALN8435G303 LLC · Beaumont, TXN8435LAarow Aircraft Leasing LLC · Mcminnville, ORN8435UMayotte Robert · Boynton Beach, FLN8435YGlobal Aviators Academy Inc · Claremont, CAN84364Innovated Control Systems Inc · Watsonville, CAN84365Abbott Troy D · Hollywood, MDN84367Martin Arthur D · New Market, VAN84369Ulrich Casey M · Waldo, KSN8436JMarshall Lee C · Hartsville, SCN8436RRegistration Pending · Riverton, KSRegistration pending, pending cancellationN8436TElias Akal Aviation LLC · Deering, NHN8436WHidalgo Robert J · El Paso, TXN8437CRobert Price Smith · Hodgenville, KYN8437DClark Donald S · Atlantic Beach, FLN8437WThomas Eric D · Placerville, CAN84386Bell Motor Co · Cut Bank, MTN8438HPitt Ian · Bergenfield, NJN8438RMorrison Doyle T · Goldthwaite, TXN8438YJohnson Aaron D · Colfax, WAN84390Butts Desmon D · New Waverly, TXN84391Vicknair Michael N · Owasso, OKN84392Romeo Flying Club LLC · Leonard, MIN84397Hernandez Karen K · Garden Valley, CAN8439MSteel Supply Co · Rolling Meadows, ILN8439TFly Quest Aviation LLC · Pomona, CAFirst renewal noticeN8439WPace Andrea · Homosassa, FLN8439YTracy Bill E · Leoti, KSN8439ZSyracuse Flying Club Inc · Fayetteville, NYN843DCJuliet Echo LLC · Sheridan, WYN843DPChoice Aviation LLC · Hamilton, MTN843GR & B Aircraft Holdings LLC · Denham Springs, LAN843RFConner Patsy L · Kerrville, TXN843SCFf22 LLC · Scottsdale, AZN843SDAftab Younus · Pleasanton, CAN844Ross George W DBA · Boise, IDN84400N84400 LLC · Chamblee, GAN84406Mio William A · Intl Falls, MNN84408Miyamoto Edward · Rio Vista, CAN8440BKoon Anthony Scott · Kokomo, INN8440DAkn Inc · Crystal, MNN8440ELand Air Enterprises · Boynton Beach, FLN8440HMeyer Anthony R · Whittemore, IAN8440LRoot William L Trustee · Scotia, NE
Back to AD 90-04-06 R1